CREATE PROCEDURE [dbo].[responses_insert]
    @bookId int,
    @content nvarchar(256),
    @dateOfPublish datetime,
    @userId int
AS
INSERT INTO [dbo].[Responses]
(   BookId,
    Content,
    DateOfPublish,
    UserId)
VALUES(
    @bookId,
    @content,
    @dateOfPublish,
    @userId)
declare @ResponseId int = @@IDENTITY

SELECT
    [ResponseId],
    [BookId],
    [Content],
    [DateOfPublish],
    [UserId]
FROM [dbo].[Responses] 
WHERE
    Responses.[ResponseId]=@ResponseId
RETURN 0
